I have lots of code which similarly runs on machine with different versions of Excel.
I took your code.. made a few changes to use a db i have (since the code is pretty straightforward.. spinning thru some views and documents and outputting stuff into excel).
A couple things I'll note in your code..
there's an On error statement ( 'On Error Goto Leave') will just exit your code if there's any notes errors .. which is probably why you're not 'seeing' any notes error when running. I commented that out in my test so, i could observe the notes issue where it occurred.
the problem which you may be having may in fact be related to the database/data you're running on.. there's a section of code ..
-----------
Set rtitem = rssdoc.GetFirstItem( "RSSAttachment" )
If ( rtitem.Type = RICHTEXT ) And rssdoc.Hasembedded Then
----------
where.. if for some reason that item (RSSAttachment) isn't in the rssdoc, the next IF statement fail.. and with your On Error statement in place, would just exit.. with no messages.
best to check to make sure the item exists before proceeding.. ala (encapsulating the if logic)
----------
Set rtitem = rssdoc.GetFirstItem( "RSSAttachment" )
If Not(rtitem Is Nothing) Then
If ( rtitem.Type = RICHTEXT ) And rssdoc.Hasembedded Then
ForAll obj In rtitem.EmbeddedObjects
.
.
End If
End If
--------
so.. i ran your code with my minor changes to refer to different views and docs and it ran fine on 2 different machines.. one running Excel/2013 (64bit) and one running Excel/2010 (32bit)
I'm guessing that you're running this on different machines.. looking at your code.. either the db's are different .. or the other possible place where there might be an error raised if where you're trying to extract an attachment and put it in c:\Windows\temp and that directory doesn't exist or the user doesn't have authority to write to that directory.
Hope that helps. I don't think it's an issue of /2013 vs /2010
Scott